#!/bin/bash
time=$(date "+%Y%m%d")

sql='alter table test1.user_clicks add partition(dt='$time');load data inpath "/user_clicks/'$time'/clicklog.dat" into table test1.user_clicks PARTITION(dt='$time');'
echo $sql > import.sql